Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAssetID (PK) | A unique, automatically assigned identifier for an asset or other item of interest that belongs to or is related to a customer. | ID_CT_AST | Identity | integer | |
Description | A narrative that describes this asset or other item belonging to a CUSTOMER. | DE_CT_AST | DescriptionNarrative | varchar(4000) | |
Make | The trade name or brand name that this asset is typcially sold under. Note brand as used here is for naming purposes it is not the same as the Brand entity which is an identified party in the retailer's suppply chain Examples: CHEVY PANASONIC SONY IKEA etc. | DE_MK | DescriptionShort | varchar(255) | |
Model | A general name that further qualifies a particular CustomerAsset.Make. Models are variation of a base Make. Examples: SONY - TRINITRON APPLE - MACBOOK PRO PENNSYLVANIAHOUSE - WILLIAMSBURG | DE_MDL | DescriptionShort | varchar(255) | |
FeatureStyle | A generic decription that qualifies a Model based on a style. Style as used here is not the same as the Style entity. Here it is a generic descriptive owned attribute used to characterize a given CustomerAsset. | DE_FTR_STYL | DescriptionShort | varchar(255) | |
FeatureColor | A generic color description to qualify a CustomerAsset.FeatureStyle. | DE_FTR_CLR | DescriptionShort | varchar(255) | |